
create database [park]
use [park]
create table [dbo].[car](
	id int,
	num char(16,
	value char(64)
)
GO

create database [backup]
use [backup]
create table [dbo].[car](
	id int,
	num char(16),
	value char(64)
)
GO
/*
use park
GO
drop TRIGGER BusRecordTRIGGER
GO
*/

use park
GO
CREATE TRIGGER BusRecordTRIGGER
ON [park].[dbo].[car]
AFTER INSERT,UPDATE
AS BEGIN INSERT INTO
[backup].[dbo].[car]
SELECT *
FROM INSERTED
END
GO

use [park]
select * from car;

use [backup]
select * from car;

use [park]
insert into car values(1,'777','')

use [park]
update car set value='test' where id=1